Connecting to Databricks

Install the Databricks ODBC Driver from here: https://www.databricks.com/spark/odbc-drivers-download

 

Example Connection String:

Driver=Simba Spark ODBC Driver;Host=adb-5273594171.11.azuredatabricks.net;Port=443;HTTPPath=/sql/1.0/warehouses/a2fa3ec5b46;ThriftTransport=2;SSL=1;AuthMech=3;UID=token;PWD=<TOKEN>

 

 

Use a Custom Query to view the list of databases:

 

You can write a Custom Query to get the list of tables in a database:

 

Finally you can write a Custom Query to retrieve the data from a table: